package com.depthsdata.coe.dao;
import java.util.Arrays;
import java.util.List;
import java.util.Map;
import net.dao.BaseQueryBean;
import net.dao.BaseWhereCriterion;
import net.dao.IDataAccessInterface;
import org.apache.commons.lang.StringUtils;
/**
 * Template Name : DAO查询对象
 * Template Version : 1
 * Template Last Modfiy Date : Sat Aug 19 10:06:32 CST 2017
 * Auto Generate Date : 2019-12-27 11:41:50
  * Warning ! This file will be overwrite when regenerate !
  * 
 */
public class BusinessProcessDiagramDAOQueryBean extends BaseQueryBean {
    
    public BusinessProcessDiagramDAOQueryBean() {
		super();
    }
	
    public BusinessProcessDiagramDAOQueryBean(BaseQueryBean aQueryBean) {
        super(aQueryBean);
    }
    
    public BusinessProcessDiagramDAOQueryBean(BaseQueryBean aQueryBean,Map tableReplaceMap) {
        super(aQueryBean,tableReplaceMap);
    }
    
    public Criteria createCriteria() {
        
	    Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
                  oredCriteria.add(criteria);
            }
        return criteria;
     }
	
    protected Criteria createCriteriaInternal() {
	  return new Criteria(this);
    }
    
        
        
    	
		
	    
    public void addIdSelectProperty(){
		addIdSelectProperty("id");
	}
	
    public void addIdSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(IBusinessProcessDiagramDAO.Id,aAlias);
		}
		else{
			addSelectProperty(IBusinessProcessDiagramDAO.Id,"id");
	    }
    }
    
       
		
		
	    
    public void addBusinessProcessIdSelectProperty(){
		addBusinessProcessIdSelectProperty("businessProcessId");
	}
	
    public void addBusinessProcessIdSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(IBusinessProcessDiagramDAO.BusinessProcessId,aAlias);
		}
		else{
			addSelectProperty(IBusinessProcessDiagramDAO.BusinessProcessId,"businessProcessId");
	    }
    }
    
       
		
		
	    
    public void addBusinessProcessDiagramSelectProperty(){
		addBusinessProcessDiagramSelectProperty("businessProcessDiagram");
	}
	
    public void addBusinessProcessDiagramSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(IBusinessProcessDiagramDAO.BusinessProcessDiagram,aAlias);
		}
		else{
			addSelectProperty(IBusinessProcessDiagramDAO.BusinessProcessDiagram,"businessProcessDiagram");
	    }
    }
    
       
		
		
	    
    public void addUpdateTimeSelectProperty(){
		addUpdateTimeSelectProperty("updateTime");
	}
	
    public void addUpdateTimeSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(IBusinessProcessDiagramDAO.UpdateTime,aAlias);
		}
		else{
			addSelectProperty(IBusinessProcessDiagramDAO.UpdateTime,"updateTime");
	    }
    }
    
       
		
		
	public void addAllSelectProperties(){
		
		
	    addIdSelectProperty();
   
		
		
	    addBusinessProcessIdSelectProperty();
   
		
		
	    addBusinessProcessDiagramSelectProperty();
   
		
		
	    addUpdateTimeSelectProperty();
   
		
	    }
    
    public static class Criteria extends BaseWhereCriterion<BusinessProcessDiagramDAOQueryBean> {
	
        protected Criteria(BusinessProcessDiagramDAOQueryBean aParentObject) {
		    super(aParentObject);
        }
        
                  
            	
    	    	
    	        
                
        public Criteria andIdIsNull() {
            addCriterion(IBusinessProcessDiagramDAO.Id + " is null");
            return this;
        }
        public Criteria andIdIsNotNull() {
            addCriterion(IBusinessProcessDiagramDAO.Id + " is not null");
            return this;
        }
    
        public Criteria andIdIsNotEmpty() {        
            addCriterion(IBusinessProcessDiagramDAO.Id + " is not null AND " + IBusinessProcessDiagramDAO.Id + " <> ''");
            return this;
        }
    		
    	public Criteria andIdIsEmpty() {       
            addCriterion("(" + IBusinessProcessDiagramDAO.Id + " is null OR " + IBusinessProcessDiagramDAO.Id + " = '')");
            return this;
        }
        
                
                        
                        
                                
        public Criteria andIdEqualTo(long value) {
        	return andIdEqualTo(Long.valueOf(value));
        }
               public Criteria andIdEqualTo(java.lang.Long value) {
        				
            addCriterion(IBusinessProcessDiagramDAO.Id + " = ", value, "id");
            return this;
        }
        
        public Criteria andIdEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessProcessDiagramDAO.Id);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andIdEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessProcessDiagramDAO.Id + " = ", subQueryBean, dao);
			return this;
		}
                
        public Criteria andIdNotEqualTo(long value) {
        	return andIdNotEqualTo(Long.valueOf(value));
        }
                public Criteria andIdNotEqualTo(java.lang.Long value) {
        	        
            addCriterion(IBusinessProcessDiagramDAO.Id + " <>", value, "id");
            return this;
        }
               
        public Criteria andIdNotEqualToOrIsNull(long value) {
        	return andIdNotEqualToOrIsNull(Long.valueOf(value));
        }
                
        public Criteria andIdNotEqualToOrIsNull(java.lang.Long value) {
        	        
            addCriterion(IBusinessProcessDiagramDAO.Id + " is null OR " + IBusinessProcessDiagramDAO.Id + " <>", value, "id");
            return this;
        }
        
        public Criteria andIdNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessProcessDiagramDAO.Id);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andIdNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessProcessDiagramDAO.Id + " <> ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andIdGreaterThan(long value) {
        	return andIdGreaterThan(Long.valueOf(value));
        }
                public Criteria andIdGreaterThan(java.lang.Long value) {
        				
            addCriterion(IBusinessProcessDiagramDAO.Id + " >", value, "id");
            return this;
        }
        
        public Criteria andIdGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessProcessDiagramDAO.Id);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andIdGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessProcessDiagramDAO.Id + " > ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andIdGreaterThanOrEqualTo(long value) {
        	return andIdGreaterThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andIdGreaterThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(IBusinessProcessDiagramDAO.Id + " >=", value, "id");
            return this;
        }
        
        public Criteria andIdGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessProcessDiagramDAO.Id);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andIdGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessProcessDiagramDAO.Id + " >= ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andIdLessThan(long value) {
        	return andIdLessThan(Long.valueOf(value));
        }
                public Criteria andIdLessThan(java.lang.Long value) {
        				
            addCriterion(IBusinessProcessDiagramDAO.Id + " <", value, "id");
            return this;
        }
        
        public Criteria andIdLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessProcessDiagramDAO.Id);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andIdLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessProcessDiagramDAO.Id + " < ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andIdLessThanOrEqualTo(long value) {
        	return andIdLessThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andIdLessThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(IBusinessProcessDiagramDAO.Id + " <=", value, "id");
            return this;
        }
        
        public Criteria andIdLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessProcessDiagramDAO.Id);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andIdLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessProcessDiagramDAO.Id + " <= ", subQueryBean, dao);
			return this;
		}
		
		        
                
        public Criteria andIdIn(long[] values) {
        	if(values.length == 1){
        		return andIdEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(IBusinessProcessDiagramDAO.Id + " in", values, "id");
            	return this;
            }
        }
        
        public Criteria andIdNotIn(long[] values) {
        	if(values.length == 1){
        		return andIdNotEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(IBusinessProcessDiagramDAO.Id + " not in", values, "id");
            	return this;
            }
        }
        
                public Criteria andIdIn(List<java.lang.Long> values) {
        	
        	if(values.size() == 1){
        		return andIdEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessProcessDiagramDAO.Id + " in", values, "id");
            	return this;
            }
        }
        public Criteria andIdNotIn(List<java.lang.Long> values) {
        	if(values.size() == 1){
        		return andIdNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessProcessDiagramDAO.Id + " not in", values, "id");
            	return this;
            }
        }
        
        public Criteria andIdIn(java.lang.Long[] values) {
        	
        	if(values.length == 1){
        		return andIdEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessProcessDiagramDAO.Id + " in", Arrays.asList(values), "id");
            	return this;
            }
        }
        public Criteria andIdNotIn(java.lang.Long[] values) {
        	if(values.length == 1){
        		return andIdNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessProcessDiagramDAO.Id + " not in", Arrays.asList(values), "id");
            	return this;
            }
        }
		
		public Criteria andIdIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessProcessDiagramDAO.Id + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andIdNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessProcessDiagramDAO.Id + " not in ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andIdBetween(long value1,long value2) {
        	addCriterion(IBusinessProcessDiagramDAO.Id + " between", value1, value2, "id");
            return this;
        }
                public Criteria andIdBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(IBusinessProcessDiagramDAO.Id + " between", value1, value2, "id");
            return this;
        }
        
                
        public Criteria andIdNotBetween(long value1,long value2) {
        	addCriterion(IBusinessProcessDiagramDAO.Id + " not between", value1, value2, "id");
            return this;
        }
                public Criteria andIdNotBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(IBusinessProcessDiagramDAO.Id + " not between", value1, value2, "id");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andBusinessProcessIdIsNull() {
            addCriterion(IBusinessProcessDiagramDAO.BusinessProcessId + " is null");
            return this;
        }
        public Criteria andBusinessProcessIdIsNotNull() {
            addCriterion(IBusinessProcessDiagramDAO.BusinessProcessId + " is not null");
            return this;
        }
    
        public Criteria andBusinessProcessIdIsNotEmpty() {        
            addCriterion(IBusinessProcessDiagramDAO.BusinessProcessId + " is not null AND " + IBusinessProcessDiagramDAO.BusinessProcessId + " <> ''");
            return this;
        }
    		
    	public Criteria andBusinessProcessIdIsEmpty() {       
            addCriterion("(" + IBusinessProcessDiagramDAO.BusinessProcessId + " is null OR " + IBusinessProcessDiagramDAO.BusinessProcessId + " = '')");
            return this;
        }
        
                
                        
                        
                                
        public Criteria andBusinessProcessIdEqualTo(long value) {
        	return andBusinessProcessIdEqualTo(Long.valueOf(value));
        }
               public Criteria andBusinessProcessIdEqualTo(java.lang.Long value) {
        				
            addCriterion(IBusinessProcessDiagramDAO.BusinessProcessId + " = ", value, "businessProcessId");
            return this;
        }
        
        public Criteria andBusinessProcessIdEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessProcessDiagramDAO.BusinessProcessId);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andBusinessProcessIdEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessProcessDiagramDAO.BusinessProcessId + " = ", subQueryBean, dao);
			return this;
		}
                
        public Criteria andBusinessProcessIdNotEqualTo(long value) {
        	return andBusinessProcessIdNotEqualTo(Long.valueOf(value));
        }
                public Criteria andBusinessProcessIdNotEqualTo(java.lang.Long value) {
        	        
            addCriterion(IBusinessProcessDiagramDAO.BusinessProcessId + " <>", value, "businessProcessId");
            return this;
        }
               
        public Criteria andBusinessProcessIdNotEqualToOrIsNull(long value) {
        	return andBusinessProcessIdNotEqualToOrIsNull(Long.valueOf(value));
        }
                
        public Criteria andBusinessProcessIdNotEqualToOrIsNull(java.lang.Long value) {
        	        
            addCriterion(IBusinessProcessDiagramDAO.BusinessProcessId + " is null OR " + IBusinessProcessDiagramDAO.BusinessProcessId + " <>", value, "businessProcessId");
            return this;
        }
        
        public Criteria andBusinessProcessIdNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessProcessDiagramDAO.BusinessProcessId);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andBusinessProcessIdNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessProcessDiagramDAO.BusinessProcessId + " <> ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andBusinessProcessIdGreaterThan(long value) {
        	return andBusinessProcessIdGreaterThan(Long.valueOf(value));
        }
                public Criteria andBusinessProcessIdGreaterThan(java.lang.Long value) {
        				
            addCriterion(IBusinessProcessDiagramDAO.BusinessProcessId + " >", value, "businessProcessId");
            return this;
        }
        
        public Criteria andBusinessProcessIdGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessProcessDiagramDAO.BusinessProcessId);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andBusinessProcessIdGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessProcessDiagramDAO.BusinessProcessId + " > ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andBusinessProcessIdGreaterThanOrEqualTo(long value) {
        	return andBusinessProcessIdGreaterThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andBusinessProcessIdGreaterThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(IBusinessProcessDiagramDAO.BusinessProcessId + " >=", value, "businessProcessId");
            return this;
        }
        
        public Criteria andBusinessProcessIdGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessProcessDiagramDAO.BusinessProcessId);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andBusinessProcessIdGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessProcessDiagramDAO.BusinessProcessId + " >= ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andBusinessProcessIdLessThan(long value) {
        	return andBusinessProcessIdLessThan(Long.valueOf(value));
        }
                public Criteria andBusinessProcessIdLessThan(java.lang.Long value) {
        				
            addCriterion(IBusinessProcessDiagramDAO.BusinessProcessId + " <", value, "businessProcessId");
            return this;
        }
        
        public Criteria andBusinessProcessIdLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessProcessDiagramDAO.BusinessProcessId);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andBusinessProcessIdLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessProcessDiagramDAO.BusinessProcessId + " < ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andBusinessProcessIdLessThanOrEqualTo(long value) {
        	return andBusinessProcessIdLessThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andBusinessProcessIdLessThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(IBusinessProcessDiagramDAO.BusinessProcessId + " <=", value, "businessProcessId");
            return this;
        }
        
        public Criteria andBusinessProcessIdLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessProcessDiagramDAO.BusinessProcessId);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andBusinessProcessIdLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessProcessDiagramDAO.BusinessProcessId + " <= ", subQueryBean, dao);
			return this;
		}
		
		        
                
        public Criteria andBusinessProcessIdIn(long[] values) {
        	if(values.length == 1){
        		return andBusinessProcessIdEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(IBusinessProcessDiagramDAO.BusinessProcessId + " in", values, "businessProcessId");
            	return this;
            }
        }
        
        public Criteria andBusinessProcessIdNotIn(long[] values) {
        	if(values.length == 1){
        		return andBusinessProcessIdNotEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(IBusinessProcessDiagramDAO.BusinessProcessId + " not in", values, "businessProcessId");
            	return this;
            }
        }
        
                public Criteria andBusinessProcessIdIn(List<java.lang.Long> values) {
        	
        	if(values.size() == 1){
        		return andBusinessProcessIdEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessProcessDiagramDAO.BusinessProcessId + " in", values, "businessProcessId");
            	return this;
            }
        }
        public Criteria andBusinessProcessIdNotIn(List<java.lang.Long> values) {
        	if(values.size() == 1){
        		return andBusinessProcessIdNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessProcessDiagramDAO.BusinessProcessId + " not in", values, "businessProcessId");
            	return this;
            }
        }
        
        public Criteria andBusinessProcessIdIn(java.lang.Long[] values) {
        	
        	if(values.length == 1){
        		return andBusinessProcessIdEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessProcessDiagramDAO.BusinessProcessId + " in", Arrays.asList(values), "businessProcessId");
            	return this;
            }
        }
        public Criteria andBusinessProcessIdNotIn(java.lang.Long[] values) {
        	if(values.length == 1){
        		return andBusinessProcessIdNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessProcessDiagramDAO.BusinessProcessId + " not in", Arrays.asList(values), "businessProcessId");
            	return this;
            }
        }
		
		public Criteria andBusinessProcessIdIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessProcessDiagramDAO.BusinessProcessId + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andBusinessProcessIdNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessProcessDiagramDAO.BusinessProcessId + " not in ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andBusinessProcessIdBetween(long value1,long value2) {
        	addCriterion(IBusinessProcessDiagramDAO.BusinessProcessId + " between", value1, value2, "businessProcessId");
            return this;
        }
                public Criteria andBusinessProcessIdBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(IBusinessProcessDiagramDAO.BusinessProcessId + " between", value1, value2, "businessProcessId");
            return this;
        }
        
                
        public Criteria andBusinessProcessIdNotBetween(long value1,long value2) {
        	addCriterion(IBusinessProcessDiagramDAO.BusinessProcessId + " not between", value1, value2, "businessProcessId");
            return this;
        }
                public Criteria andBusinessProcessIdNotBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(IBusinessProcessDiagramDAO.BusinessProcessId + " not between", value1, value2, "businessProcessId");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andBusinessProcessDiagramIsNull() {
            addCriterion(IBusinessProcessDiagramDAO.BusinessProcessDiagram + " is null");
            return this;
        }
        public Criteria andBusinessProcessDiagramIsNotNull() {
            addCriterion(IBusinessProcessDiagramDAO.BusinessProcessDiagram + " is not null");
            return this;
        }
    
        public Criteria andBusinessProcessDiagramIsNotEmpty() {        
            addCriterion(IBusinessProcessDiagramDAO.BusinessProcessDiagram + " is not null AND " + IBusinessProcessDiagramDAO.BusinessProcessDiagram + " <> ''");
            return this;
        }
    		
    	public Criteria andBusinessProcessDiagramIsEmpty() {       
            addCriterion("(" + IBusinessProcessDiagramDAO.BusinessProcessDiagram + " is null OR " + IBusinessProcessDiagramDAO.BusinessProcessDiagram + " = '')");
            return this;
        }
        
                
                        
                        
                               public Criteria andBusinessProcessDiagramEqualTo(String value) {
        				
            addCriterion(IBusinessProcessDiagramDAO.BusinessProcessDiagram + " = ", value, "businessProcessDiagram");
            return this;
        }
        
        public Criteria andBusinessProcessDiagramEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessProcessDiagramDAO.BusinessProcessDiagram);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andBusinessProcessDiagramEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessProcessDiagramDAO.BusinessProcessDiagram + " = ", subQueryBean, dao);
			return this;
		}
                public Criteria andBusinessProcessDiagramNotEqualTo(String value) {
        	        
            addCriterion(IBusinessProcessDiagramDAO.BusinessProcessDiagram + " <>", value, "businessProcessDiagram");
            return this;
        }
               
        public Criteria andBusinessProcessDiagramNotEqualToOrIsNull(String value) {
        	        
            addCriterion(IBusinessProcessDiagramDAO.BusinessProcessDiagram + " is null OR " + IBusinessProcessDiagramDAO.BusinessProcessDiagram + " <>", value, "businessProcessDiagram");
            return this;
        }
        
        public Criteria andBusinessProcessDiagramNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessProcessDiagramDAO.BusinessProcessDiagram);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andBusinessProcessDiagramNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessProcessDiagramDAO.BusinessProcessDiagram + " <> ", subQueryBean, dao);
			return this;
		}
               public Criteria andBusinessProcessDiagramGreaterThan(String value) {
        				
            addCriterion(IBusinessProcessDiagramDAO.BusinessProcessDiagram + " >", value, "businessProcessDiagram");
            return this;
        }
        
        public Criteria andBusinessProcessDiagramGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessProcessDiagramDAO.BusinessProcessDiagram);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andBusinessProcessDiagramGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessProcessDiagramDAO.BusinessProcessDiagram + " > ", subQueryBean, dao);
			return this;
		}
               public Criteria andBusinessProcessDiagramGreaterThanOrEqualTo(String value) {
        				
            addCriterion(IBusinessProcessDiagramDAO.BusinessProcessDiagram + " >=", value, "businessProcessDiagram");
            return this;
        }
        
        public Criteria andBusinessProcessDiagramGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessProcessDiagramDAO.BusinessProcessDiagram);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andBusinessProcessDiagramGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessProcessDiagramDAO.BusinessProcessDiagram + " >= ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andBusinessProcessDiagramLessThan(String value) {
        				
            addCriterion(IBusinessProcessDiagramDAO.BusinessProcessDiagram + " <", value, "businessProcessDiagram");
            return this;
        }
        
        public Criteria andBusinessProcessDiagramLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessProcessDiagramDAO.BusinessProcessDiagram);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andBusinessProcessDiagramLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessProcessDiagramDAO.BusinessProcessDiagram + " < ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andBusinessProcessDiagramLessThanOrEqualTo(String value) {
        				
            addCriterion(IBusinessProcessDiagramDAO.BusinessProcessDiagram + " <=", value, "businessProcessDiagram");
            return this;
        }
        
        public Criteria andBusinessProcessDiagramLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessProcessDiagramDAO.BusinessProcessDiagram);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andBusinessProcessDiagramLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessProcessDiagramDAO.BusinessProcessDiagram + " <= ", subQueryBean, dao);
			return this;
		}
		
				
        public Criteria andBusinessProcessDiagramLike(String value) {
        	StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(IBusinessProcessDiagramDAO.BusinessProcessDiagram + " like", buffer.toString(), "businessProcessDiagram");
            return this;
        }
        public Criteria andBusinessProcessDiagramNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(IBusinessProcessDiagramDAO.BusinessProcessDiagram + " not like", buffer.toString(), "businessProcessDiagram");
            return this;
        }
                
                public Criteria andBusinessProcessDiagramIn(List<String> values) {
        	
        	if(values.size() == 1){
        		return andBusinessProcessDiagramEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessProcessDiagramDAO.BusinessProcessDiagram + " in", values, "businessProcessDiagram");
            	return this;
            }
        }
        public Criteria andBusinessProcessDiagramNotIn(List<String> values) {
        	if(values.size() == 1){
        		return andBusinessProcessDiagramNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessProcessDiagramDAO.BusinessProcessDiagram + " not in", values, "businessProcessDiagram");
            	return this;
            }
        }
        
        public Criteria andBusinessProcessDiagramIn(String[] values) {
        	
        	if(values.length == 1){
        		return andBusinessProcessDiagramEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessProcessDiagramDAO.BusinessProcessDiagram + " in", Arrays.asList(values), "businessProcessDiagram");
            	return this;
            }
        }
        public Criteria andBusinessProcessDiagramNotIn(String[] values) {
        	if(values.length == 1){
        		return andBusinessProcessDiagramNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessProcessDiagramDAO.BusinessProcessDiagram + " not in", Arrays.asList(values), "businessProcessDiagram");
            	return this;
            }
        }
		
		public Criteria andBusinessProcessDiagramIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessProcessDiagramDAO.BusinessProcessDiagram + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andBusinessProcessDiagramNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessProcessDiagramDAO.BusinessProcessDiagram + " not in ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andBusinessProcessDiagramBetween(String value1, String value2) {
            addCriterion(IBusinessProcessDiagramDAO.BusinessProcessDiagram + " between", value1, value2, "businessProcessDiagram");
            return this;
        }
        
                public Criteria andBusinessProcessDiagramNotBetween(String value1, String value2) {
            addCriterion(IBusinessProcessDiagramDAO.BusinessProcessDiagram + " not between", value1, value2, "businessProcessDiagram");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andUpdateTimeIsNull() {
            addCriterion(IBusinessProcessDiagramDAO.UpdateTime + " is null");
            return this;
        }
        public Criteria andUpdateTimeIsNotNull() {
            addCriterion(IBusinessProcessDiagramDAO.UpdateTime + " is not null");
            return this;
        }
    
        public Criteria andUpdateTimeIsNotEmpty() {        
            addCriterion(IBusinessProcessDiagramDAO.UpdateTime + " is not null AND " + IBusinessProcessDiagramDAO.UpdateTime + " <> ''");
            return this;
        }
    		
    	public Criteria andUpdateTimeIsEmpty() {       
            addCriterion("(" + IBusinessProcessDiagramDAO.UpdateTime + " is null OR " + IBusinessProcessDiagramDAO.UpdateTime + " = '')");
            return this;
        }
        
                
                        
                        
                               public Criteria andUpdateTimeEqualTo(java.util.Date value) {
        				
            addCriterionForJDBCDate(IBusinessProcessDiagramDAO.UpdateTime + " = ", value, "updateTime");
            return this;
        }
        
        public Criteria andUpdateTimeEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessProcessDiagramDAO.UpdateTime);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andUpdateTimeEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessProcessDiagramDAO.UpdateTime + " = ", subQueryBean, dao);
			return this;
		}
                public Criteria andUpdateTimeNotEqualTo(java.util.Date value) {
        	        
            addCriterionForJDBCDate(IBusinessProcessDiagramDAO.UpdateTime + " <>", value, "updateTime");
            return this;
        }
               
        public Criteria andUpdateTimeNotEqualToOrIsNull(java.util.Date value) {
        	        
            addCriterionForJDBCDate(IBusinessProcessDiagramDAO.UpdateTime + " is null OR " + IBusinessProcessDiagramDAO.UpdateTime + " <>", value, "updateTime");
            return this;
        }
        
        public Criteria andUpdateTimeNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessProcessDiagramDAO.UpdateTime);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andUpdateTimeNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessProcessDiagramDAO.UpdateTime + " <> ", subQueryBean, dao);
			return this;
		}
               public Criteria andUpdateTimeGreaterThan(java.util.Date value) {
        				
            addCriterionForJDBCDate(IBusinessProcessDiagramDAO.UpdateTime + " >", value, "updateTime");
            return this;
        }
        
        public Criteria andUpdateTimeGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessProcessDiagramDAO.UpdateTime);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andUpdateTimeGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessProcessDiagramDAO.UpdateTime + " > ", subQueryBean, dao);
			return this;
		}
               public Criteria andUpdateTimeGreaterThanOrEqualTo(java.util.Date value) {
        				
            addCriterionForJDBCDate(IBusinessProcessDiagramDAO.UpdateTime + " >=", value, "updateTime");
            return this;
        }
        
        public Criteria andUpdateTimeGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessProcessDiagramDAO.UpdateTime);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andUpdateTimeGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessProcessDiagramDAO.UpdateTime + " >= ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andUpdateTimeLessThan(java.util.Date value) {
        				
            addCriterionForJDBCDate(IBusinessProcessDiagramDAO.UpdateTime + " <", value, "updateTime");
            return this;
        }
        
        public Criteria andUpdateTimeLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessProcessDiagramDAO.UpdateTime);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andUpdateTimeLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessProcessDiagramDAO.UpdateTime + " < ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andUpdateTimeLessThanOrEqualTo(java.util.Date value) {
        				
            addCriterionForJDBCDate(IBusinessProcessDiagramDAO.UpdateTime + " <=", value, "updateTime");
            return this;
        }
        
        public Criteria andUpdateTimeLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessProcessDiagramDAO.UpdateTime);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andUpdateTimeLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessProcessDiagramDAO.UpdateTime + " <= ", subQueryBean, dao);
			return this;
		}
		
		        
                public Criteria andUpdateTimeIn(List<java.util.Date> values) {
        	
        	if(values.size() == 1){
        		return andUpdateTimeEqualTo(values.get(0));
        	}
        	else{
            	addCriterionForJDBCDate(IBusinessProcessDiagramDAO.UpdateTime + " in", values, "updateTime");
            	return this;
            }
        }
        public Criteria andUpdateTimeNotIn(List<java.util.Date> values) {
        	if(values.size() == 1){
        		return andUpdateTimeNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterionForJDBCDate(IBusinessProcessDiagramDAO.UpdateTime + " not in", values, "updateTime");
            	return this;
            }
        }
        
        public Criteria andUpdateTimeIn(java.util.Date[] values) {
        	
        	if(values.length == 1){
        		return andUpdateTimeEqualTo(values[0]);
        	}
        	else{
            	addCriterionForJDBCDate(IBusinessProcessDiagramDAO.UpdateTime + " in", Arrays.asList(values), "updateTime");
            	return this;
            }
        }
        public Criteria andUpdateTimeNotIn(java.util.Date[] values) {
        	if(values.length == 1){
        		return andUpdateTimeNotEqualTo(values[0]);
        	}
        	else{
            	addCriterionForJDBCDate(IBusinessProcessDiagramDAO.UpdateTime + " not in", Arrays.asList(values), "updateTime");
            	return this;
            }
        }
		
		public Criteria andUpdateTimeIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessProcessDiagramDAO.UpdateTime + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andUpdateTimeNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessProcessDiagramDAO.UpdateTime + " not in ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andUpdateTimeBetween(java.util.Date value1, java.util.Date value2) {
            addCriterionForJDBCDate(IBusinessProcessDiagramDAO.UpdateTime + " between", value1, value2, "updateTime");
            return this;
        }
        
                public Criteria andUpdateTimeNotBetween(java.util.Date value1, java.util.Date value2) {
            addCriterionForJDBCDate(IBusinessProcessDiagramDAO.UpdateTime + " not between", value1, value2, "updateTime");
            return this;
        }
        
            	
    	    	
    	        
        
    }
	
    
}